Tonight's favourite words are LEFT JOIN (although ON DELETE CASCADE is still high in my esteem - take that, test data! Ha!).
Note to self (and others who've had similar join troubles):
When you want everything in the FIRST table you list that meets your condition, along with the related data you want from one or more other tables, to show up in
(
Read more... )